Electricity Report

Dataset statistics

Number of variables	9
Number of observations	419403
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	91
Duplicate rows (%)	< 0.1%
Total size in memory	32.0 MiB
Average record size in memory	80.0 B

Variable types

Numeric	9

Alerts

Dataset has 91 (< 0.1%) duplicate rows	Duplicates
`Consumption_MW` is highly overall correlated with `Coal_MW` and 2 other fields	High correlation
`Coal_MW` is highly overall correlated with `Consumption_MW`	High correlation
`Gas_MW` is highly overall correlated with `Consumption_MW` and 1 other fields	High correlation
`Production_MW` is highly overall correlated with `Consumption_MW` and 1 other fields	High correlation
`Wind_MW` has 27315 (6.5%) zeros	Zeros
`Solar_MW` has 219493 (52.3%) zeros	Zeros
`Biomass_MW` has 183783 (43.8%) zeros	Zeros

Reproduction

Analysis started	2023-01-27 06:46:09.173821
Analysis finished	2023-01-27 06:46:28.821650
Duration	19.65 seconds
Software version	pandas-profiling vv3.6.3
Download configuration	config.json

Consumption_MW
Real number (ℝ)

Distinct	5515
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6608.5451

Minimum	44
Maximum	26209
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	44
5-th percentile	5078
Q1	5834
median	6578
Q3	7279
95-th percentile	8388
Maximum	26209
Range	26165
Interquartile range (IQR)	1445

Descriptive statistics

Standard deviation	1007.541
Coefficient of variation (CV)	0.15246034
Kurtosis	-0.049936456
Mean	6608.5451
Median Absolute Deviation (MAD)	724
Skewness	0.26206434
Sum	2.7716436 × 10⁹
Variance	1015138.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6588	347	0.1%
6482	255	0.1%
6722	215	0.1%
6686	203	< 0.1%
6795	202	< 0.1%
6727	202	< 0.1%
6581	201	< 0.1%
6542	201	< 0.1%
6770	199	< 0.1%
6578	198	< 0.1%
Other values (5505)	417180	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
44	1	< 0.1%
47	1	< 0.1%
94	1	< 0.1%
95	1	< 0.1%
3666	1	< 0.1%
3667	1	< 0.1%
3698	1	< 0.1%
3709	1	< 0.1%
3713	1	< 0.1%
3714	2	< 0.1%

Value	Count	Frequency (%)
26209	1	< 0.1%
21007	1	< 0.1%
9865	1	< 0.1%
9826	1	< 0.1%
9807	1	< 0.1%
9784	1	< 0.1%
9766	1	< 0.1%
9739	1	< 0.1%
9729	1	< 0.1%
9721	1	< 0.1%

Coal_MW
Real number (ℝ)

Distinct	3840
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2257.7754

Minimum	-485
Maximum	5702
Zeros	0
Zeros (%)	0.0%
Negative	2
Negative (%)	< 0.1%
Memory size	6.4 MiB

Quantile statistics

Minimum	-485
5-th percentile	1346
Q1	1834
median	2196
Q3	2652.5
95-th percentile	3340
Maximum	5702
Range	6187
Interquartile range (IQR)	818.5

Descriptive statistics

Standard deviation	610.83659
Coefficient of variation (CV)	0.27054799
Kurtosis	-0.081301491
Mean	2257.7754
Median Absolute Deviation (MAD)	403
Skewness	0.30978281
Sum	9.4691776 × 10⁸
Variance	373121.34
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2593	395	0.1%
2088	344	0.1%
2040	342	0.1%
2073	340	0.1%
1917	338	0.1%
2150	335	0.1%
2134	334	0.1%
2001	334	0.1%
2081	333	0.1%
2105	333	0.1%
Other values (3830)	415975	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-485	1	< 0.1%
-43	1	< 0.1%
50	2	< 0.1%
357	1	< 0.1%
358	4	< 0.1%
359	4	< 0.1%
360	2	< 0.1%
362	3	< 0.1%
364	4	< 0.1%
365	2	< 0.1%

Value	Count	Frequency (%)
5702	1	< 0.1%
5338	1	< 0.1%
4408	1	< 0.1%
4395	1	< 0.1%
4383	1	< 0.1%
4370	1	< 0.1%
4369	1	< 0.1%
4368	1	< 0.1%
4365	1	< 0.1%
4353	1	< 0.1%

Gas_MW
Real number (ℝ)

Distinct	2300
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1008.1513

Minimum	-414
Maximum	2666
Zeros	2
Zeros (%)	< 0.1%
Negative	1
Negative (%)	< 0.1%
Memory size	6.4 MiB

Quantile statistics

Minimum	-414
5-th percentile	366
Q1	604
median	984
Q3	1329
95-th percentile	1871
Maximum	2666
Range	3080
Interquartile range (IQR)	725

Descriptive statistics

Standard deviation	469.65867
Coefficient of variation (CV)	0.4658613
Kurtosis	-0.52466816
Mean	1008.1513
Median Absolute Deviation (MAD)	365
Skewness	0.41476628
Sum	4.2282167 × 10⁸
Variance	220579.26
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
416	778	0.2%
417	702	0.2%
415	638	0.2%
400	592	0.1%
418	576	0.1%
398	569	0.1%
397	567	0.1%
424	564	0.1%
399	556	0.1%
423	553	0.1%
Other values (2290)	413308	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-414	1	< 0.1%
0	2	< 0.1%
29	1	< 0.1%
33	1	< 0.1%
116	1	< 0.1%
120	9	< 0.1%
121	2	< 0.1%
128	1	< 0.1%
129	8	< 0.1%
130	13	< 0.1%

Value	Count	Frequency (%)
2666	1	< 0.1%
2660	1	< 0.1%
2659	1	< 0.1%
2651	1	< 0.1%
2506	1	< 0.1%
2504	2	< 0.1%
2501	1	< 0.1%
2499	1	< 0.1%
2463	1	< 0.1%
2458	2	< 0.1%

Hidroelectric_MW
Real number (ℝ)

Distinct	4221
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1840.6141

Minimum	0
Maximum	4728
Zeros	21
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	669
Q1	1262
median	1809
Q3	2395
95-th percentile	3100
Maximum	4728
Range	4728
Interquartile range (IQR)	1133

Descriptive statistics

Standard deviation	754.03004
Coefficient of variation (CV)	0.40966222
Kurtosis	-0.56491018
Mean	1840.6141
Median Absolute Deviation (MAD)	566
Skewness	0.18254896
Sum	7.7195906 × 10⁸
Variance	568561.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2476	359	0.1%
1550	239	0.1%
1573	238	0.1%
2012	232	0.1%
1913	229	0.1%
1621	229	0.1%
1435	228	0.1%
1505	228	0.1%
1649	227	0.1%
1774	226	0.1%
Other values (4211)	416968	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21	< 0.1%
53	1	< 0.1%
56	1	< 0.1%
58	1	< 0.1%
59	2	< 0.1%
60	3	< 0.1%
85	1	< 0.1%
87	2	< 0.1%
90	1	< 0.1%
91	1	< 0.1%

Value	Count	Frequency (%)
4728	1	< 0.1%
4706	1	< 0.1%
4700	1	< 0.1%
4692	1	< 0.1%
4687	1	< 0.1%
4680	1	< 0.1%
4668	1	< 0.1%
4664	1	< 0.1%
4663	1	< 0.1%
4656	1	< 0.1%

Nuclear_MW
Real number (ℝ)

Distinct	879
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1320.4078

Minimum	0
Maximum	1450
Zeros	129
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	702
Q1	1377
median	1403
Q3	1419
95-th percentile	1427
Maximum	1450
Range	1450
Interquartile range (IQR)	42

Descriptive statistics

Standard deviation	223.18161
Coefficient of variation (CV)	0.16902476
Kurtosis	4.0827664
Mean	1320.4078
Median Absolute Deviation (MAD)	19
Skewness	-2.4101529
Sum	5.5378299 × 10⁸
Variance	49810.03
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1421	11618	2.8%
1422	11318	2.7%
1423	11129	2.7%
1420	11038	2.6%
1419	10593	2.5%
1424	10450	2.5%
1418	9729	2.3%
1425	9619	2.3%
1417	8851	2.1%
1426	8417	2.0%
Other values (869)	316641	75.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	129	< 0.1%
37	1	< 0.1%
39	4	< 0.1%
40	3	< 0.1%
44	1	< 0.1%
45	1	< 0.1%
47	1	< 0.1%
49	1	< 0.1%
70	1	< 0.1%
83	1	< 0.1%

Value	Count	Frequency (%)
1450	1	< 0.1%
1443	1	< 0.1%
1441	3	< 0.1%
1440	11	< 0.1%
1439	13	< 0.1%
1438	29	< 0.1%
1437	52	< 0.1%
1436	113	< 0.1%
1435	252	0.1%
1434	374	0.1%

Wind_MW
Real number (ℝ)

Distinct	2828
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	501.87965

Minimum	-521
Maximum	7944
Zeros	27315
Zeros (%)	6.5%
Negative	11515
Negative (%)	2.7%
Memory size	6.4 MiB

Quantile statistics

Minimum	-521
5-th percentile	0
Q1	64
median	272
Q3	733
95-th percentile	1804
Maximum	7944
Range	8465
Interquartile range (IQR)	669

Descriptive statistics

Standard deviation	585.6012
Coefficient of variation (CV)	1.166816
Kurtosis	1.7646362
Mean	501.87965
Median Absolute Deviation (MAD)	247
Skewness	1.5177154
Sum	2.1048983 × 10⁸
Variance	342928.77
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	27315	6.5%
-1	3060	0.7%
-2	2222	0.5%
3	1655	0.4%
1	1559	0.4%
2	1531	0.4%
5	1390	0.3%
4	1383	0.3%
-3	1379	0.3%
6	1332	0.3%
Other values (2818)	376577	89.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-521	2	< 0.1%
-26	3	< 0.1%
-25	18	< 0.1%
-24	32	< 0.1%
-23	34	< 0.1%
-22	57	< 0.1%
-21	41	< 0.1%
-20	54	< 0.1%
-19	52	< 0.1%
-18	84	< 0.1%

Value	Count	Frequency (%)
7944	1	< 0.1%
2806	1	< 0.1%
2803	1	< 0.1%
2802	1	< 0.1%
2800	2	< 0.1%
2799	1	< 0.1%
2798	2	< 0.1%
2797	1	< 0.1%
2796	1	< 0.1%
2795	1	< 0.1%

Solar_MW
Real number (ℝ)

Distinct	857
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.445168

Minimum	-6
Maximum	859
Zeros	219493
Zeros (%)	52.3%
Negative	78275
Negative (%)	18.7%
Memory size	6.4 MiB

Quantile statistics

Minimum	-6
5-th percentile	-1
Q1	0
median	0
Q3	16
95-th percentile	492
Maximum	859
Range	865
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	161.3681
Coefficient of variation (CV)	2.2906908
Kurtosis	5.5075357
Mean	70.445168
Median Absolute Deviation (MAD)	0
Skewness	2.5121392
Sum	29544915
Variance	26039.664
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	219493	52.3%
-1	78214	18.6%
1	3468	0.8%
2	1704	0.4%
3	1322	0.3%
4	1189	0.3%
5	1011	0.2%
6	915	0.2%
7	912	0.2%
8	854	0.2%
Other values (847)	110321	26.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6	1	< 0.1%
-4	8	< 0.1%
-3	41	< 0.1%
-2	11	< 0.1%
-1	78214	18.6%
0	219493	52.3%
1	3468	0.8%
2	1704	0.4%
3	1322	0.3%
4	1189	0.3%

Value	Count	Frequency (%)
859	1	< 0.1%
858	1	< 0.1%
854	1	< 0.1%
852	2	< 0.1%
851	1	< 0.1%
848	1	< 0.1%
847	1	< 0.1%
845	1	< 0.1%
844	1	< 0.1%
843	1	< 0.1%

Biomass_MW
Real number (ℝ)

Distinct	101
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.365593

Minimum	0
Maximum	110
Zeros	183783
Zeros (%)	43.8%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	33
Q3	55
95-th percentile	67
Maximum	110
Range	110
Interquartile range (IQR)	55

Descriptive statistics

Standard deviation	27.424163
Coefficient of variation (CV)	0.93388758
Kurtosis	-1.7138335
Mean	29.365593
Median Absolute Deviation (MAD)	33
Skewness	0.036152394
Sum	12316018
Variance	752.08472
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	183783	43.8%
33	14475	3.5%
57	9318	2.2%
52	9217	2.2%
55	9201	2.2%
58	9046	2.2%
61	8868	2.1%
64	7630	1.8%
56	7551	1.8%
53	7520	1.8%
Other values (91)	152794	36.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	183783	43.8%
10	3	< 0.1%
11	33	< 0.1%
12	72	< 0.1%
13	14	< 0.1%
14	26	< 0.1%
15	13	< 0.1%
16	104	< 0.1%
17	230	0.1%
18	68	< 0.1%

Value	Count	Frequency (%)
110	4	< 0.1%
109	14	< 0.1%
108	11	< 0.1%
107	11	< 0.1%
106	3	< 0.1%
105	5	< 0.1%
104	3	< 0.1%
103	3	< 0.1%
102	3	< 0.1%
100	1	< 0.1%

Production_MW
Real number (ℝ)

Distinct	6936
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7028.7707

Minimum	0
Maximum	11295
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	5208
Q1	6177
median	6973
Q3	7820
95-th percentile	9058
Maximum	11295
Range	11295
Interquartile range (IQR)	1643

Descriptive statistics

Standard deviation	1169.3226
Coefficient of variation (CV)	0.16636232
Kurtosis	-0.31859478
Mean	7028.7707
Median Absolute Deviation (MAD)	821
Skewness	0.23015593
Sum	2.9478875 × 10⁹
Variance	1367315.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7001	322	0.1%
7066	252	0.1%
6697	177	< 0.1%
6840	176	< 0.1%
6654	174	< 0.1%
6696	174	< 0.1%
6732	169	< 0.1%
6673	169	< 0.1%
6734	168	< 0.1%
6860	167	< 0.1%
Other values (6926)	417455	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
44	1	< 0.1%
47	1	< 0.1%
50	1	< 0.1%
744	1	< 0.1%
936	1	< 0.1%
3616	1	< 0.1%
3621	1	< 0.1%
3671	1	< 0.1%
3675	1	< 0.1%

Value	Count	Frequency (%)
11295	1	< 0.1%
11227	1	< 0.1%
11219	1	< 0.1%
11205	1	< 0.1%
11183	1	< 0.1%
11153	1	< 0.1%
11150	1	< 0.1%
11146	1	< 0.1%
11138	1	< 0.1%
11131	1	< 0.1%

Auto

Heatmap
Table

	Consumption_MW	Coal_MW	Gas_MW	Hidroelectric_MW	Nuclear_MW	Wind_MW	Solar_MW	Biomass_MW	Production_MW
Consumption_MW	1.000	0.547	0.557	0.420	0.092	0.068	0.137	0.038	0.891
Coal_MW	0.547	1.000	0.304	-0.000	0.105	-0.345	-0.049	-0.397	0.440
Gas_MW	0.557	0.304	1.000	-0.193	0.241	0.162	-0.056	0.169	0.537
Hidroelectric_MW	0.420	-0.000	-0.193	1.000	-0.195	-0.168	0.186	0.120	0.470
Nuclear_MW	0.092	0.105	0.241	-0.195	1.000	-0.000	-0.215	-0.200	0.098
Wind_MW	0.068	-0.345	0.162	-0.168	-0.000	1.000	-0.012	0.464	0.249
Solar_MW	0.137	-0.049	-0.056	0.186	-0.215	-0.012	1.000	0.114	0.142
Biomass_MW	0.038	-0.397	0.169	0.120	-0.200	0.464	0.114	1.000	0.229
Production_MW	0.891	0.440	0.537	0.470	0.098	0.249	0.142	0.229	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Consumption_MW	Coal_MW	Gas_MW	Hidroelectric_MW	Nuclear_MW	Wind_MW	Solar_MW	Biomass_MW	Production_MW
Date
1262487660	5302.0	1754.0	1144.0	1391.0	706.0	0.0	0.0	0.0	4995.0
1262488200	5318.0	1777.0	1145.0	1468.0	708.0	0.0	0.0	0.0	5097.0
1262488800	5268.0	1743.0	1139.0	1361.0	708.0	0.0	0.0	0.0	4951.0
1262489400	5358.0	1759.0	1142.0	1449.0	707.0	0.0	0.0	0.0	5057.0
1262490060	5327.0	1764.0	1142.0	1417.0	709.0	0.0	0.0	0.0	5031.0
1262490660	5307.0	1771.0	1142.0	1418.0	706.0	0.0	0.0	0.0	5037.0
1262491260	5256.0	1752.0	1153.0	1368.0	712.0	0.0	0.0	0.0	4985.0
1262492400	5308.0	1762.0	1151.0	1461.0	709.0	0.0	0.0	0.0	5083.0
1262493000	5426.0	1785.0	1153.0	1515.0	704.0	0.0	0.0	0.0	5157.0
1262493660	5340.0	1782.0	1150.0	1488.0	706.0	0.0	0.0	0.0	5126.0

	Consumption_MW	Coal_MW	Gas_MW	Hidroelectric_MW	Nuclear_MW	Wind_MW	Solar_MW	Biomass_MW	Production_MW
Date
1514942465	7307.0	2328.0	955.0	1311.0	1404.0	2269.0	-1.0	43.0	8308.0
1514943055	7295.0	2250.0	941.0	1335.0	1404.0	2244.0	-1.0	44.0	8217.0
1514943645	7272.0	2253.0	946.0	1395.0	1404.0	2205.0	-1.0	45.0	8246.0
1514944235	7266.0	2239.0	946.0	1387.0	1406.0	2204.0	-1.0	44.0	8224.0
1514944825	7287.0	2275.0	945.0	1425.0	1401.0	2193.0	-1.0	45.0	8283.0
1514945415	7262.0	2279.0	942.0	1444.0	1403.0	2175.0	-1.0	45.0	8287.0
1514946005	7167.0	2259.0	943.0	1383.0	1405.0	2174.0	-1.0	43.0	8207.0
1514946595	7122.0	2251.0	945.0	1362.0	1405.0	2159.0	-1.0	45.0	8165.0
1514947185	7264.0	2288.0	944.0	1454.0	1406.0	2132.0	-1.0	45.0	8268.0
1514947775	7115.0	2255.0	944.0	1370.0	1404.0	2131.0	-1.0	41.0	8145.0

Most frequently occurring

	Consumption_MW	Coal_MW	Gas_MW	Hidroelectric_MW	Nuclear_MW	Wind_MW	Solar_MW	Biomass_MW	Production_MW	# duplicates
35	6588.0	2593.0	515.0	2476.0	1421.0	-1.0	0.0	0.0	7001.0	195
31	6482.0	2460.0	277.0	2941.0	1383.0	3.0	0.0	0.0	7066.0	114
67	7411.0	2160.0	1842.0	1315.0	1423.0	610.0	0.0	0.0	7349.0	34
39	6687.0	3103.0	783.0	932.0	1373.0	253.0	0.0	0.0	6446.0	28
74	7672.0	2026.0	826.0	2557.0	694.0	2575.0	468.0	69.0	9216.0	18
87	8211.0	3294.0	2203.0	1579.0	1424.0	-1.0	43.0	33.0	8573.0	18
64	7331.0	2428.0	1516.0	1590.0	1406.0	269.0	197.0	56.0	7462.0	15
86	8182.0	3167.0	1733.0	1793.0	1393.0	538.0	22.0	46.0	8686.0	11
37	6667.0	2616.0	522.0	2525.0	1414.0	9.0	0.0	0.0	7088.0	10
58	7048.0	3521.0	481.0	1287.0	1407.0	300.0	0.0	0.0	6996.0	10

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring